-- phpMyAdmin SQL Dump
-- version 3.3.8.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: May 23, 2013 at 07:39 AM
-- Server version: 5.0.91
-- PHP Version: 5.3.6-pl0-gentoo

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `deferranti_pc`
--

-- --------------------------------------------------------

--
-- Table structure for table `about`
--

CREATE TABLE IF NOT EXISTS `about` (
  `id_About` int(8) NOT NULL auto_increment,
  `Title_About` varchar(250) default NULL,
  `Introduction_About` text,
  `Description_About` text,
  PRIMARY KEY  (`id_About`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

-- --------------------------------------------------------

--
-- Table structure for table `admin_roles`
--

CREATE TABLE IF NOT EXISTS `admin_roles` (
  `id_Roles` int(11) NOT NULL auto_increment,
  `Name_Roles` varchar(48) NOT NULL,
  `Description_Roles` varchar(128) NOT NULL,
  PRIMARY KEY  (`id_Roles`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

-- --------------------------------------------------------

--
-- Table structure for table `admin_users`
--

CREATE TABLE IF NOT EXISTS `admin_users` (
  `id` int(11) NOT NULL auto_increment,
  `Username` varchar(36) NOT NULL,
  `Password` varchar(128) NOT NULL,
  `Role` varchar(2) NOT NULL,
  `Active` varchar(1) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

INSERT INTO `admin_users` (`id`, `Username`, `Password`, `Role`, `Active`) VALUES
(1, 'admin', '5f4dcc3b5aa765d61d8327deb882cf99', '1', '1');

-- --------------------------------------------------------

--
-- Table structure for table `applications`
--

CREATE TABLE IF NOT EXISTS `applications` (
  `id_Applications` int(11) NOT NULL auto_increment,
  `Name_Applications` varchar(200) default NULL,
  `Image_Applications` varchar(128) NOT NULL,
  `Active_Applications` varchar(1) NOT NULL default '1',
  PRIMARY KEY  (`id_Applications`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=38 ;

-- --------------------------------------------------------

--
-- Table structure for table `applications_products`
--

CREATE TABLE IF NOT EXISTS `applications_products` (
  `id_Applications` varchar(36) default NULL,
  `id_Products` varchar(36) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `articles`
--

CREATE TABLE IF NOT EXISTS `articles` (
  `id_Articles` varchar(36) NOT NULL,
  `Title_Articles` varchar(250) default NULL,
  `Date_Articles` date default NULL,
  `Introduction_Articles` text,
  `Description_Articles` text,
  `Image_Articles` varchar(128) default NULL,
  `Active_Articles` tinyint(1) default '0',
  `Approved_Articles` tinyint(1) default '0',
  PRIMARY KEY  (`id_Articles`),
  FULLTEXT KEY `FULLTEXT` (`Title_Articles`,`Introduction_Articles`,`Description_Articles`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `career_opportunities`
--

CREATE TABLE IF NOT EXISTS `career_opportunities` (
  `id_Career_Opportunities` varchar(36) NOT NULL,
  `Title_Career_Opportunities` varchar(255) NOT NULL,
  `Description_Career_Opportunities` text,
  `Active_Career_Opportunities` tinyint(1) default '0',
  `Approved_Career_Opportunities` tinyint(1) default '0',
  PRIMARY KEY  (`Title_Career_Opportunities`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `categories`
--

CREATE TABLE IF NOT EXISTS `categories` (
  `id_Categories` varchar(36) NOT NULL,
  `Parent_Categories` varchar(36) default NULL,
  `Title_Categories` varchar(250) NOT NULL,
  `Introduction_Categories` text NOT NULL,
  `Description_Categories` text,
  `Image_Categories` varchar(128) NOT NULL,
  `Active_Categories` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id_Categories`),
  FULLTEXT KEY `Title_Categories` (`Title_Categories`,`Introduction_Categories`,`Description_Categories`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `crm`
--

CREATE TABLE IF NOT EXISTS `crm` (
  `id_Users` varchar(36) NOT NULL,
  `id_AdminUser` varchar(36) NOT NULL,
  `Notes` text NOT NULL,
  PRIMARY KEY  (`id_Users`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `exhibitions`
--

CREATE TABLE IF NOT EXISTS `exhibitions` (
  `id_Exhibitions` varchar(36) NOT NULL,
  `Title_Exhibitions` varchar(250) default NULL,
  `Date_Exhibitions` date default NULL,
  `Date2_Exhibitions` date default NULL,
  `Introduction_Exhibitions` text,
  `Description_Exhibitions` text,
  `Image_Exhibitions` varchar(128) default NULL,
  `Active_Exhibitions` tinyint(1) default '0',
  `Approved_Exhibitions` tinyint(1) default '0',
  PRIMARY KEY  (`id_Exhibitions`),
  FULLTEXT KEY `FULLTEXT` (`Title_Exhibitions`,`Introduction_Exhibitions`,`Description_Exhibitions`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `faqs`
--

CREATE TABLE IF NOT EXISTS `faqs` (
  `id_FAQs` varchar(36) NOT NULL,
  `Title_FAQs` varchar(255) NOT NULL,
  `Description_FAQs` text NOT NULL,
  `Active_FAQs` tinyint(1) default '0',
  `Approved_FAQs` tinyint(1) default '0',
  PRIMARY KEY  (`Title_FAQs`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `finishes`
--

CREATE TABLE IF NOT EXISTS `finishes` (
  `id_Finishes` int(11) NOT NULL auto_increment,
  `Name_Finishes` varchar(200) NOT NULL,
  `Active_Finishes` binary(1) NOT NULL default '1',
  PRIMARY KEY  (`id_Finishes`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=22 ;

-- --------------------------------------------------------

--
-- Table structure for table `finishes_products`
--

CREATE TABLE IF NOT EXISTS `finishes_products` (
  `id_Finishes` varchar(36) NOT NULL,
  `id_Products` varchar(36) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `friends`
--

CREATE TABLE IF NOT EXISTS `friends` (
  `id_Friends` varchar(36) NOT NULL,
  `Title_Friends` varchar(256) NOT NULL,
  `Introduction_Friends` text,
  `Description_Friends` text,
  `Image_Friends` varchar(128) default NULL,
  `Active_Friends` tinyint(1) default '0',
  `Approved_Friends` tinyint(1) default '0',
  PRIMARY KEY  (`id_Friends`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `gallery`
--

CREATE TABLE IF NOT EXISTS `gallery` (
  `id_Gallery` int(11) NOT NULL auto_increment,
  `Image_Gallery` varchar(128) NOT NULL,
  `Active_Gallery` tinyint(4) NOT NULL default '1',
  PRIMARY KEY  (`id_Gallery`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

-- --------------------------------------------------------

--
-- Table structure for table `glossary`
--

CREATE TABLE IF NOT EXISTS `glossary` (
  `id_Glossary` varchar(36) NOT NULL default '',
  `Title_Glossary` varchar(250) NOT NULL default '',
  `Introduction_Glossary` text,
  `Description_Glossary` text,
  `Image_Glossary` varchar(128) default NULL,
  `Active_Glossary` tinyint(1) default '0',
  `Approved_Glossary` tinyint(1) default '0',
  PRIMARY KEY  (`Title_Glossary`),
  FULLTEXT KEY `FULLTEXT` (`Title_Glossary`,`Introduction_Glossary`,`Description_Glossary`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `news`
--

CREATE TABLE IF NOT EXISTS `news` (
  `id_News` varchar(36) NOT NULL default '',
  `Title_News` text,
  `Date_News` date default NULL,
  `Introduction_News` text,
  `Description_News` text,
  `Image_News` varchar(128) default NULL,
  `isHighlight_News` char(1) default NULL,
  `Active_News` tinyint(1) default '0',
  `Approved_News` tinyint(1) default '0',
  PRIMARY KEY  (`id_News`),
  FULLTEXT KEY `FULLTEXT` (`Title_News`,`Introduction_News`,`Description_News`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `newsletters`
--

CREATE TABLE IF NOT EXISTS `newsletters` (
  `id_Newsletters` varchar(36) NOT NULL,
  `Date_Newsletters` date default NULL,
  `Title_Newsletters` varchar(250) default NULL,
  `Summary_Newsletters` text,
  `URL_Newsletters` varchar(250) default NULL,
  `Image_Newsletters` varchar(128) default NULL,
  `Active_Newsletters` char(1) character set utf8 collate utf8_bin default NULL,
  `Approved_Newsletters` char(1) character set utf8 collate utf8_bin default NULL,
  PRIMARY KEY  (`id_Newsletters`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `pageheaders`
--

CREATE TABLE IF NOT EXISTS `pageheaders` (
  `id_Pageheaders` varchar(36) NOT NULL,
  `Title_Pageheaders` varchar(255) NOT NULL,
  `Introduction_Pageheaders` text,
  `Description_Pageheaders` text,
  PRIMARY KEY  (`id_Pageheaders`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `portfolio`
--

CREATE TABLE IF NOT EXISTS `portfolio` (
  `id_Portfolio` varchar(36) NOT NULL,
  `Name_Portfolio` varchar(250) default NULL,
  `Introduction_Portfolio` text,
  `Description_Portfolio` text,
  `Main_Image` varchar(128) default NULL,
  `Active_Portfolio` tinyint(1) default '0',
  `Approved_Portfolio` tinyint(1) default '0',
  PRIMARY KEY  (`id_Portfolio`),
  FULLTEXT KEY `FULLTEXT` (`Name_Portfolio`,`Introduction_Portfolio`,`Description_Portfolio`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `portfolios_images`
--

CREATE TABLE IF NOT EXISTS `portfolios_images` (
  `id_Portfolio` varchar(36) NOT NULL,
  `Image` varchar(128) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `portfolios_products`
--

CREATE TABLE IF NOT EXISTS `portfolios_products` (
  `id_Products` varchar(36) default NULL,
  `id_Portfolio` varchar(36) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `products`
--

CREATE TABLE IF NOT EXISTS `products` (
  `id_Products` varchar(36) NOT NULL default '',
  `Name_Products` varchar(250) default NULL,
  `Introduction_Products` text,
  `Description_Products` text,
  `Main_Image` varchar(128) NOT NULL,
  `Big_Image` varchar(128) default NULL,
  `id_Categories` varchar(36) NOT NULL,
  `DateAdded_Products` date default NULL,
  `Active_Products` tinyint(1) NOT NULL default '0',
  `Approved_Products` tinyint(1) NOT NULL default '0',
  `id_Supplier` varchar(36) NOT NULL,
  `Code_Products` varchar(36) default NULL,
  `Price_Products` decimal(36,2) unsigned default NULL,
  `Currency_Products` varchar(20) default NULL,
  `pdf_Products` varchar(128) NOT NULL,
  PRIMARY KEY  (`id_Products`),
  FULLTEXT KEY `Name_Products` (`Name_Products`,`Introduction_Products`,`Description_Products`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `products_images`
--

CREATE TABLE IF NOT EXISTS `products_images` (
  `id_Products` varchar(36) NOT NULL,
  `Image` varchar(128) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `products_users`
--

CREATE TABLE IF NOT EXISTS `products_users` (
  `id_Users` varchar(36) NOT NULL,
  `id_Products` varchar(36) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `publicity`
--

CREATE TABLE IF NOT EXISTS `publicity` (
  `id_Publicity` varchar(36) NOT NULL default '',
  `Title_Publicity` varchar(250) default NULL,
  `Date_Publicity` date default NULL,
  `Introduction_Publicity` text,
  `Description_Publicity` text,
  `Image_Publicity` varchar(128) default NULL,
  `Active_Publicity` tinyint(1) default '0',
  `Approved_Publicity` tinyint(1) default '0',
  PRIMARY KEY  (`id_Publicity`),
  FULLTEXT KEY `FULLTEXT` (`Title_Publicity`,`Introduction_Publicity`,`Description_Publicity`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `specs`
--

CREATE TABLE IF NOT EXISTS `specs` (
  `id_Specs` int(11) NOT NULL auto_increment,
  `Name_Specs` varchar(80) NOT NULL,
  `Active_Specs` binary(1) NOT NULL default '1',
  KEY `id_Specs` (`id_Specs`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;

-- --------------------------------------------------------

--
-- Table structure for table `specs_products`
--

CREATE TABLE IF NOT EXISTS `specs_products` (
  `id_Specs` varchar(36) NOT NULL,
  `id_Products` varchar(36) NOT NULL,
  `Value` varchar(150) NOT NULL,
  `id_Units` int(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `supplier`
--

CREATE TABLE IF NOT EXISTS `supplier` (
  `id_Supplier` varchar(36) NOT NULL default '',
  `Code_Supplier` varchar(200) default NULL,
  `Name_Supplier` varchar(250) NOT NULL,
  `ContactName_Supplier` varchar(250) default NULL,
  `Address_Supplier` text,
  `Phone_Supplier` varchar(100) default NULL,
  `Fax_Supplier` varchar(100) default NULL,
  `Mobile_Supplier` varchar(100) default NULL,
  `Email_Supplier` varchar(200) default NULL,
  `WebSite_Supplier` varchar(200) default NULL,
  `City_Supplier` varchar(200) default NULL,
  `Address2_Supplier` text,
  `State_Supplier` varchar(200) default NULL,
  `Country_Supplier` varchar(200) default NULL,
  `PostCode_Supplier` varchar(200) default NULL,
  PRIMARY KEY  (`id_Supplier`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `units`
--

CREATE TABLE IF NOT EXISTS `units` (
  `id_Units` int(11) NOT NULL auto_increment,
  `name_Units` varchar(100) NOT NULL,
  PRIMARY KEY  (`id_Units`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

-- --------------------------------------------------------

--
-- Table structure for table `users`
--

CREATE TABLE IF NOT EXISTS `users` (
  `id_Users` varchar(36) NOT NULL default '',
  `UserName_Users` varchar(250) NOT NULL default '',
  `UserPassword_Users` varchar(128) default NULL,
  `Active_Users` tinyint(1) NOT NULL default '1',
  `Approved_Users` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`UserName_Users`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `usersdetails`
--

CREATE TABLE IF NOT EXISTS `usersdetails` (
  `id_Users` varchar(36) NOT NULL,
  `Title_UsersDetails` varchar(8) default NULL,
  `FirstName_UsersDetails` varchar(100) default NULL,
  `LastName_UsersDetails` varchar(100) default NULL,
  `CompanyName_UsersDetails` varchar(200) default NULL,
  `Address_UsersDetails` varchar(250) default NULL,
  `City_UsersDetails` varchar(100) default NULL,
  `State_UsersDetails` varchar(100) default NULL,
  `ZipCode_UsersDetails` varchar(50) default NULL,
  `Country_UsersDetails` varchar(100) default NULL,
  `DaytimePhone_UsersDetails` varchar(30) default NULL,
  `Mobile_UsersDetails` varchar(30) default NULL,
  `Email_UsersDetails` varchar(200) default NULL,
  `MailingList_UsersDetails` char(1) default NULL,
  `ProfessionalDesignations` varchar(36) default NULL,
  `DateJoined_UsersDetails` datetime NOT NULL,
  `DateDeactivated_UsersDetails` datetime NOT NULL,
  `LastLogin_UsersDetails` datetime NOT NULL,
  `NumberLogins_UsersDetails` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id_Users`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `wishlists`
--

CREATE TABLE IF NOT EXISTS `wishlists` (
  `id_Wishlists` int(11) NOT NULL auto_increment,
  `id_Users` varchar(36) NOT NULL,
  `Title_Wishlists` varchar(128) NOT NULL,
  PRIMARY KEY  (`id_Wishlists`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=386 ;

-- --------------------------------------------------------

--
-- Table structure for table `wishlists_products`
--

CREATE TABLE IF NOT EXISTS `wishlists_products` (
  `id_Wishlists` varchar(36) NOT NULL,
  `id_Products` varchar(36) NOT NULL,
  `DateAdded_Wishlists` datetime NOT NULL,
  `DateEnquired_Wishlists` datetime default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
